﻿INSERT INTO SchemaVersion(VersionNumber, IsCurrent) VALUES(1, 1);


INSERT INTO ServiceStatus(Code, Comment) VALUES('AC', 'Active taxi service');
INSERT INTO ServiceStatus(Code, Comment) VALUES('PE', 'Pending taxi service');
INSERT INTO ServiceStatus(Code, Comment) VALUES('DS', 'Disabled taxi service');
INSERT INTO ServiceStatus(Code, Comment) VALUES('DL', 'Deleted taxi service');

INSERT INTO TransportType(Code, Comment) VALUES('SDN', 'Sedan car for passengers');
INSERT INTO TransportType(Code, Comment) VALUES('HTC', 'Hatchback car for passengers');
INSERT INTO TransportType(Code, Comment) VALUES('MIN', 'Mini car for passengers');
INSERT INTO TransportType(Code, Comment) VALUES('LIM', 'Limusine for passengers');
INSERT INTO TransportType(Code, Comment) VALUES('JEP', 'Jeep car for passengers');
INSERT INTO TransportType(Code, Comment) VALUES('SPT', 'Sport car for passengers');
INSERT INTO TransportType(Code, Comment) VALUES('RTR', 'Retro car for passengers');
INSERT INTO TransportType(Code, Comment) VALUES('EXC', 'Exclusive car for passengers');
INSERT INTO TransportType(Code, Comment) VALUES('CRG', 'Cargo for transporting');

INSERT INTO District(DistrictId, NameEN, NameRU, NameAM) VALUES(1,'Avan, Avan-Arinj', 'Аван, Аван-Ариндж', 'Ավան-Առինջ');
INSERT INTO District(DistrictId, NameEN, NameRU, NameAM) VALUES(2,'Arabkir', 'Арабкир', 'Արաբկիր');
INSERT INTO District(DistrictId, NameEN, NameRU, NameAM) VALUES(3,'Achapnyak', 'Ачапняк', 'Աչափնյակ');
INSERT INTO District(DistrictId, NameEN, NameRU, NameAM) VALUES(4,'Davtashen', 'Давташен', 'Դավթաշեն');
INSERT INTO District(DistrictId, NameEN, NameRU, NameAM) VALUES(5,'Center', 'Центр', 'Կենտրոն');
INSERT INTO District(DistrictId, NameEN, NameRU, NameAM) VALUES(6,'Kanaker-Zeytun', 'Канакер-Зейтун', 'Քանաքեռ-Զեյթուն');
INSERT INTO District(DistrictId, NameEN, NameRU, NameAM) VALUES(7,'Malatia-Sebastia', 'Малатия-Себастия', 'Մալաթիա-Սեբաստիա');
INSERT INTO District(DistrictId, NameEN, NameRU, NameAM) VALUES(8,'Small Center', 'Малый Центр', 'Փոքր Կենտրոն');
INSERT INTO District(DistrictId, NameEN, NameRU, NameAM) VALUES(9,'Nor Nork', 'Нор Норк', 'Նոր Նորք');
INSERT INTO District(DistrictId, NameEN, NameRU, NameAM) VALUES(10,'Nork-Marash', 'Норк-Мараш', 'Նորք-Մարաշ');
INSERT INTO District(DistrictId, NameEN, NameRU, NameAM) VALUES(11,'Shengavit', 'Шенгавит', 'Շենգավիթ');
INSERT INTO District(DistrictId, NameEN, NameRU, NameAM) VALUES(12,'Erebuni', 'Эребуни', 'Էրեբունի');


SET IDENTITY_INSERT Car ON
GO

INSERT INTO Car(CarId, TypeCode, Make, MaxPassenger, Class, Model, Year, CreateDate)
VALUES(1, 'SDN', 'VAZ', 4, 1, '2107', 2000, GETDATE());

INSERT INTO Car(CarId, TypeCode, Make, MaxPassenger, Class, Model, Year, CreateDate)
VALUES(2, 'SDN', 'VAZ', 4, 1, '2106', 2000, GETDATE());

INSERT INTO Car(CarId, TypeCode, Make, MaxPassenger, Class, Model, Year, CreateDate)
VALUES(3, 'SDN', 'GAZ', 4, 2, '31105', 2004, GETDATE());

INSERT INTO Car(CarId, TypeCode, Make, MaxPassenger, Class, Model, Year, CreateDate)
VALUES(4, 'SDN', 'Lada', 4, 2, 'Kalina', 2005, GETDATE());

INSERT INTO Car(CarId, TypeCode, Make, MaxPassenger, Class, Model, Year, CreateDate)
VALUES(5, 'SDN', 'Lada', 4, 2, '110', 1996, GETDATE());

INSERT INTO Car(CarId, TypeCode, Make, MaxPassenger, Class, Model, Year, CreateDate)
VALUES(6, 'SDN', 'Daewoo', 4, 3, 'Nexia', 2002, GETDATE());

INSERT INTO Car(CarId, TypeCode, Make, MaxPassenger, Class, Model, Year, CreateDate)
VALUES(7, 'SDN', 'IKCO', 4, 3, 'Samand', 2003, GETDATE());

INSERT INTO Car(CarId, TypeCode, Make, MaxPassenger, Class, Model, Year, CreateDate)
VALUES(8, 'SDN', 'Mitsubishi', 4, 4, 'Lancer', 2000, GETDATE());

INSERT INTO Car(CarId, TypeCode, Make, MaxPassenger, Class, Model, Year, CreateDate)
VALUES(9, 'SDN', 'Renault', 4, 4, 'Clio/Symbol', 1998, GETDATE());

INSERT INTO Car(CarId, TypeCode, Make, MaxPassenger, Class, Model, Year, CreateDate)
VALUES(10, 'SDN', 'Skoda', 4, 5, 'Octavia', 1996, GETDATE());

INSERT INTO Car(CarId, TypeCode, Make, MaxPassenger, Class, Model, Year, CreateDate)
VALUES(11, 'SDN', 'Skoda', 4, 5, 'Roomster', 2006, GETDATE());

INSERT INTO Car(CarId, TypeCode, Make, MaxPassenger, Class, Model, Year, CreateDate)
VALUES(12, 'SDN', 'Chevrolet', 5, 3, 'Aveo', 2006, GETDATE());


INSERT INTO Car(CarId, TypeCode, Make, MaxPassenger, Class, Model, Year, CreateDate)
VALUES(13, 'SDN', 'BYD', 4, 5, 'F3', 2008, GETDATE());

INSERT INTO Car(CarId, TypeCode, Make, MaxPassenger, Class, Model, Year, CreateDate)
VALUES(14, 'SDN', 'Toyota', 4, 6, 'Corolla', 2007, GETDATE());

SET IDENTITY_INSERT Car OFF
GO
